Reporte de perfilamiento

Dataset statistics

Number of variables	17
Number of observations	8950
Missing cells	314
Missing cells (%)	0.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.5 MiB
Average record size in memory	173.5 B

Variable types

Numeric	17

Alerts

`AVANCE_EFECTIVO` is highly overall correlated with `COMPRAS` and 11 other fields	High correlation
`COMPRAS` is highly overall correlated with `AVANCE_EFECTIVO` and 7 other fields	High correlation
`COMPRAS_PLAZOS` is highly overall correlated with `AVANCE_EFECTIVO` and 13 other fields	High correlation
`COMPRAS_PUNTUALES` is highly overall correlated with `AVANCE_EFECTIVO` and 13 other fields	High correlation
`F_AVANCE_EFECTIVO` is highly overall correlated with `COMPRAS_PLAZOS` and 5 other fields	High correlation
`F_COMPRAS` is highly overall correlated with `AVANCE_EFECTIVO` and 10 other fields	High correlation
`F_COMPRAS_PLAZOS` is highly overall correlated with `COMPRAS_PLAZOS` and 5 other fields	High correlation
`F_COMPRAS_PUNTUALES` is highly overall correlated with `AVANCE_EFECTIVO` and 8 other fields	High correlation
`F_PAGOS_COMPLETOS` is highly overall correlated with `AVANCE_EFECTIVO` and 10 other fields	High correlation
`F_SALDO` is highly overall correlated with `AVANCE_EFECTIVO` and 9 other fields	High correlation
`LÍMITE_CREDITO` is highly overall correlated with `F_PAGOS_COMPLETOS` and 2 other fields	High correlation
`MESES_CLIENTE` is highly overall correlated with `AVANCE_EFECTIVO` and 7 other fields	High correlation
`PAGOS` is highly overall correlated with `AVANCE_EFECTIVO` and 10 other fields	High correlation
`PAGOS_MINIMOS` is highly overall correlated with `AVANCE_EFECTIVO` and 8 other fields	High correlation
`P_AVANCE_EFECTIVO` is highly overall correlated with `AVANCE_EFECTIVO` and 4 other fields	High correlation
`P_COMPRAS` is highly overall correlated with `COMPRAS_PLAZOS` and 6 other fields	High correlation
`SALDO` is highly overall correlated with `AVANCE_EFECTIVO` and 7 other fields	High correlation
`PAGOS_MINIMOS` has 313 (3.5%) missing values	Missing
`F_SALDO` has unique values	Unique
`COMPRAS` has unique values	Unique
`COMPRAS_PUNTUALES` has unique values	Unique
`COMPRAS_PLAZOS` has unique values	Unique
`AVANCE_EFECTIVO` has unique values	Unique
`F_COMPRAS` has unique values	Unique
`F_COMPRAS_PUNTUALES` has unique values	Unique
`F_COMPRAS_PLAZOS` has unique values	Unique
`F_AVANCE_EFECTIVO` has unique values	Unique
`PAGOS` has unique values	Unique
`F_PAGOS_COMPLETOS` has unique values	Unique

Reproduction

Analysis started	2025-03-13 01:41:44.018790
Analysis finished	2025-03-13 01:42:57.842975
Duration	1 minute and 13.82 seconds
Software version	ydata-profiling vv4.14.0
Download configuration	config.json

SALDO
Real number (ℝ)

High correlation

Distinct	8949
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9382.3879

Minimum	0
Maximum	19043.139
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	397.9 KiB

Quantile statistics

Minimum	0
5-th percentile	2854.8674
Q1	4275.0369
median	12007.719
Q3	13740.566
95-th percentile	16580.242
Maximum	19043.139
Range	19043.139
Interquartile range (IQR)	9465.529

Descriptive statistics

Standard deviation	5118.1136
Coefficient of variation (CV)	0.54550223
Kurtosis	-1.7041396
Mean	9382.3879
Median Absolute Deviation (MAD)	4947.4812
Skewness	-0.0098065752
Sum	83972372
Variance	26195086
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13048.17538	2	< 0.1%
5323.148883	1	< 0.1%
2894.440826	1	< 0.1%
12568.17469	1	< 0.1%
12531.4608	1	< 0.1%
13456.59149	1	< 0.1%
12711.09785	1	< 0.1%
13388.78627	1	< 0.1%
5413.777486	1	< 0.1%
13511.28823	1	< 0.1%
Other values (8939)	8939	99.9%

Value	Count	Frequency (%)
0	1	< 0.1%
885.0757034	1	< 0.1%
1008.382846	1	< 0.1%
1043.390879	1	< 0.1%
1072.89289	1	< 0.1%
1098.764703	1	< 0.1%
1108.161419	1	< 0.1%
1118.313734	1	< 0.1%
1125.764249	1	< 0.1%
1175.757312	1	< 0.1%

Value	Count	Frequency (%)
19043.13856	1	< 0.1%
18569.42652	1	< 0.1%
18497.07354	1	< 0.1%
18434.97796	1	< 0.1%
18397.4101	1	< 0.1%
18384.028	1	< 0.1%
18339.7197	1	< 0.1%
18308.96883	1	< 0.1%
18252.25624	1	< 0.1%
18233.67155	1	< 0.1%

F_SALDO
Real number (ℝ)

High correlation Unique

Distinct	8950
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.45920527

Minimum	0
Maximum	1
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	397.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0.12088099
Q1	0.18849012
median	0.30664968
Q3	0.7560605
95-th percentile	0.83542186
Maximum	1
Range	1
Interquartile range (IQR)	0.56757038

Descriptive statistics

Standard deviation	0.28299772
Coefficient of variation (CV)	0.61627717
Kurtosis	-1.7668724
Mean	0.45920527
Median Absolute Deviation (MAD)	0.21291151
Skewness	0.11596109
Sum	4109.8871
Variance	0.080087712
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.250692707	1	< 0.1%
0.725720857	1	< 0.1%
0.846129553	1	< 0.1%
0.138971189	1	< 0.1%
0.815383263	1	< 0.1%
0.653521965	1	< 0.1%
0.79179445	1	< 0.1%
0.771520379	1	< 0.1%
0.523217439	1	< 0.1%
0.190372367	1	< 0.1%
Other values (8940)	8940	99.9%

Value	Count	Frequency (%)
0	1	< 0.1%
0.010427583	1	< 0.1%
0.014856227	1	< 0.1%
0.021585154	1	< 0.1%
0.02194965	1	< 0.1%
0.023505901	1	< 0.1%
0.025894801	1	< 0.1%
0.027843806	1	< 0.1%
0.030474901	1	< 0.1%
0.032863616	1	< 0.1%

Value	Count	Frequency (%)
1	1	< 0.1%
0.939610773	1	< 0.1%
0.936658899	1	< 0.1%
0.935383007	1	< 0.1%
0.932518174	1	< 0.1%
0.931677127	1	< 0.1%
0.923863815	1	< 0.1%
0.920708863	1	< 0.1%
0.920004014	1	< 0.1%
0.919001899	1	< 0.1%

COMPRAS
Real number (ℝ)

High correlation Unique

Distinct	8950
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	30525.873

Minimum	0
Maximum	49039.57
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	397.9 KiB

Quantile statistics

Minimum	0
5-th percentile	6616.995
Q1	27106.652
median	30934.582
Q3	39825.161
95-th percentile	43316.606
Maximum	49039.57
Range	49039.57
Interquartile range (IQR)	12718.509

Descriptive statistics

Standard deviation	11041.411
Coefficient of variation (CV)	0.36170663
Kurtosis	0.21198459
Mean	30525.873
Median Absolute Deviation (MAD)	6943.5872
Skewness	-0.98275394
Sum	2.7320657 × 10⁸
Variance	1.2191276 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26344.0722	1	< 0.1%
41437.06432	1	< 0.1%
43779.4274	1	< 0.1%
28258.13329	1	< 0.1%
42817.61455	1	< 0.1%
41108.43375	1	< 0.1%
44493.57963	1	< 0.1%
41012.43728	1	< 0.1%
26343.59408	1	< 0.1%
29907.99005	1	< 0.1%
Other values (8940)	8940	99.9%

Value	Count	Frequency (%)
0	1	< 0.1%
802.5621109	1	< 0.1%
1030.085201	1	< 0.1%
1095.306246	1	< 0.1%
1856.714976	1	< 0.1%
1877.730395	1	< 0.1%
1970.558086	1	< 0.1%
1980.687874	1	< 0.1%
1995.799837	1	< 0.1%
2046.231017	1	< 0.1%

Value	Count	Frequency (%)
49039.57	1	< 0.1%
48228.03931	1	< 0.1%
47404.00743	1	< 0.1%
47381.97436	1	< 0.1%
47359.68992	1	< 0.1%
47141.1223	1	< 0.1%
46918.90384	1	< 0.1%
46891.48848	1	< 0.1%
46801.62683	1	< 0.1%
46647.03585	1	< 0.1%

COMPRAS_PUNTUALES
Real number (ℝ)

High correlation Unique

Distinct	8950
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22913.666

Minimum	0
Maximum	40761.25
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	397.9 KiB

Quantile statistics

Minimum	0
5-th percentile	4333.5648
Q1	6698.2525
median	31011.033
Q3	34495.416
95-th percentile	36929.564
Maximum	40761.25
Range	40761.25
Interquartile range (IQR)	27797.164

Descriptive statistics

Standard deviation	13573.919
Coefficient of variation (CV)	0.59239404
Kurtosis	-1.7263916
Mean	22913.666
Median Absolute Deviation (MAD)	4975.9527
Skewness	-0.40878713
Sum	2.0507731 × 10⁸
Variance	1.8425128 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
38237.44252	1	< 0.1%
5362.933728	1	< 0.1%
5033.507182	1	< 0.1%
36005.104	1	< 0.1%
6096.311227	1	< 0.1%
7480.473162	1	< 0.1%
7388.158309	1	< 0.1%
3651.156999	1	< 0.1%
31353.8312	1	< 0.1%
35957.10776	1	< 0.1%
Other values (8940)	8940	99.9%

Value	Count	Frequency (%)
0	1	< 0.1%
354.6224778	1	< 0.1%
916.1213738	1	< 0.1%
969.8717684	1	< 0.1%
1158.864719	1	< 0.1%
1198.052851	1	< 0.1%
1225.548277	1	< 0.1%
1314.469823	1	< 0.1%
1426.650583	1	< 0.1%
1467.924848	1	< 0.1%

Value	Count	Frequency (%)
40761.25	1	< 0.1%
40494.4017	1	< 0.1%
40411.58254	1	< 0.1%
40378.13101	1	< 0.1%
40349.45022	1	< 0.1%
40298.4978	1	< 0.1%
40104.52639	1	< 0.1%
39967.37278	1	< 0.1%
39947.12194	1	< 0.1%
39942.58007	1	< 0.1%

COMPRAS_PLAZOS
Real number (ℝ)

High correlation Unique

Distinct	8950
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11407.852

Minimum	0
Maximum	22500
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	397.9 KiB

Quantile statistics

Minimum	0
5-th percentile	2311.397
Q1	3736.7202
median	10832.141
Q3	19127.083
95-th percentile	20486.675
Maximum	22500
Range	22500
Interquartile range (IQR)	15390.363

Descriptive statistics

Standard deviation	7087.103
Coefficient of variation (CV)	0.62124781
Kurtosis	-1.6290421
Mean	11407.852
Median Absolute Deviation (MAD)	7629.1438
Skewness	0.024009418
Sum	1.0210027 × 10⁸
Variance	50227029
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3727.113162	1	< 0.1%
20804.5293	1	< 0.1%
18471.90619	1	< 0.1%
4536.012866	1	< 0.1%
19267.79499	1	< 0.1%
19557.49091	1	< 0.1%
20686.76067	1	< 0.1%
18522.99067	1	< 0.1%
9010.635829	1	< 0.1%
4235.515719	1	< 0.1%
Other values (8940)	8940	99.9%

Value	Count	Frequency (%)
0	1	< 0.1%
291.4350444	1	< 0.1%
306.3587599	1	< 0.1%
420.8859033	1	< 0.1%
428.5092786	1	< 0.1%
486.4719017	1	< 0.1%
627.4056257	1	< 0.1%
628.6425918	1	< 0.1%
648.6134924	1	< 0.1%
702.8437687	1	< 0.1%

Value	Count	Frequency (%)
22500	1	< 0.1%
22445.19219	1	< 0.1%
22295.53069	1	< 0.1%
22154.51792	1	< 0.1%
22117.11387	1	< 0.1%
22021.44059	1	< 0.1%
22013.27978	1	< 0.1%
22012.8644	1	< 0.1%
22005.36194	1	< 0.1%
21951.52724	1	< 0.1%

AVANCE_EFECTIVO
Real number (ℝ)

High correlation Unique

Distinct	8950
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22573.474

Minimum	0
Maximum	47137.212
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	397.9 KiB

Quantile statistics

Minimum	0
5-th percentile	7012.1109
Q1	10944.431
median	19465.792
Q3	36150.723
95-th percentile	40572.083
Maximum	47137.212
Range	47137.212
Interquartile range (IQR)	25206.291

Descriptive statistics

Standard deviation	12594.296
Coefficient of variation (CV)	0.55792457
Kurtosis	-1.5988803
Mean	22573.474
Median Absolute Deviation (MAD)	10850.018
Skewness	0.21537149
Sum	2.0203259 × 10⁸
Variance	1.5861629 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15708.23968	1	< 0.1%
36506.31873	1	< 0.1%
39084.83617	1	< 0.1%
7058.118437	1	< 0.1%
39118.40863	1	< 0.1%
31439.06137	1	< 0.1%
39705.07662	1	< 0.1%
38603.70918	1	< 0.1%
4625.479787	1	< 0.1%
12973.24828	1	< 0.1%
Other values (8940)	8940	99.9%

Value	Count	Frequency (%)
0	1	< 0.1%
444.180016	1	< 0.1%
767.2506051	1	< 0.1%
1667.744275	1	< 0.1%
1851.092454	1	< 0.1%
1875.702282	1	< 0.1%
1928.362354	1	< 0.1%
2369.725445	1	< 0.1%
2487.948408	1	< 0.1%
2647.126977	1	< 0.1%

Value	Count	Frequency (%)
47137.21176	1	< 0.1%
46470.12694	1	< 0.1%
46394.29124	1	< 0.1%
45747.75649	1	< 0.1%
45628.08385	1	< 0.1%
45476.09724	1	< 0.1%
45219.3376	1	< 0.1%
45164.82939	1	< 0.1%
45146.60223	1	< 0.1%
45141.25977	1	< 0.1%

F_COMPRAS
Real number (ℝ)

High correlation Unique

Distinct	8950
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.55981002

Minimum	0
Maximum	1
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	397.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0.20331681
Q1	0.40727318
median	0.50530452
Q3	0.7770837
95-th percentile	0.86479798
Maximum	1
Range	1
Interquartile range (IQR)	0.36981052

Descriptive statistics

Standard deviation	0.21405474
Coefficient of variation (CV)	0.38237033
Kurtosis	-1.0985196
Mean	0.55981002
Median Absolute Deviation (MAD)	0.17765663
Skewness	-0.027693024
Sum	5010.2997
Variance	0.045819432
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.496535855	1	< 0.1%
0.883631682	1	< 0.1%
0.77727304	1	< 0.1%
0.388050467	1	< 0.1%
0.812677656	1	< 0.1%
0.832239216	1	< 0.1%
0.749221444	1	< 0.1%
0.777377855	1	< 0.1%
0.109919235	1	< 0.1%
0.411019006	1	< 0.1%
Other values (8940)	8940	99.9%

Value	Count	Frequency (%)
0	1	< 0.1%
0.040958035	1	< 0.1%
0.046248735	1	< 0.1%
0.046857727	1	< 0.1%
0.04998949	1	< 0.1%
0.050787224	1	< 0.1%
0.05638137	1	< 0.1%
0.060709924	1	< 0.1%
0.064944785	1	< 0.1%
0.067918099	1	< 0.1%

Value	Count	Frequency (%)
1	1	< 0.1%
0.999194116	1	< 0.1%
0.998470526	1	< 0.1%
0.997711347	1	< 0.1%
0.988014567	1	< 0.1%
0.986604764	1	< 0.1%
0.977364949	1	< 0.1%
0.974017266	1	< 0.1%
0.973889019	1	< 0.1%
0.973881002	1	< 0.1%

F_COMPRAS_PUNTUALES
Real number (ℝ)

High correlation Unique

Distinct	8950
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.47803224

Minimum	0
Maximum	1
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	397.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0.153228
Q1	0.25085559
median	0.53352102
Q3	0.64911958
95-th percentile	0.80963312
Maximum	1
Range	1
Interquartile range (IQR)	0.39826399

Descriptive statistics

Standard deviation	0.22187326
Coefficient of variation (CV)	0.46413869
Kurtosis	-1.2660164
Mean	0.47803224
Median Absolute Deviation (MAD)	0.20131508
Skewness	-0.073036402
Sum	4278.3885
Variance	0.049227742
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.464442158	1	< 0.1%
0.308493142	1	< 0.1%
0.237406009	1	< 0.1%
0.566880671	1	< 0.1%
0.194713638	1	< 0.1%
0.202100795	1	< 0.1%
0.22500664	1	< 0.1%
0.179431	1	< 0.1%
0.752303194	1	< 0.1%
0.573390431	1	< 0.1%
Other values (8940)	8940	99.9%

Value	Count	Frequency (%)
0	1	< 0.1%
0.031308334	1	< 0.1%
0.031661187	1	< 0.1%
0.050872919	1	< 0.1%
0.054947643	1	< 0.1%
0.057340594	1	< 0.1%
0.057911991	1	< 0.1%
0.05884068	1	< 0.1%
0.059907398	1	< 0.1%
0.061399317	1	< 0.1%

Value	Count	Frequency (%)
1	1	< 0.1%
0.998947367	1	< 0.1%
0.984298283	1	< 0.1%
0.9823838	1	< 0.1%
0.980166562	1	< 0.1%
0.978558397	1	< 0.1%
0.977949401	1	< 0.1%
0.970915648	1	< 0.1%
0.968876608	1	< 0.1%
0.96837024	1	< 0.1%

F_COMPRAS_PLAZOS
Real number (ℝ)

High correlation Unique

Distinct	8950
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.62391568

Minimum	0
Maximum	1
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	397.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0.17461492
Q1	0.51823052
median	0.60760758
Q3	0.81492919
95-th percentile	0.89275532
Maximum	1
Range	1
Interquartile range (IQR)	0.29669867

Descriptive statistics

Standard deviation	0.2082072
Coefficient of variation (CV)	0.33371048
Kurtosis	-0.028872187
Mean	0.62391568
Median Absolute Deviation (MAD)	0.13699256
Skewness	-0.66151997
Sum	5584.0454
Variance	0.043350238
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.821610917	1	< 0.1%
0.580985209	1	< 0.1%
0.514425934	1	< 0.1%
0.848701303	1	< 0.1%
0.593445387	1	< 0.1%
0.521138327	1	< 0.1%
0.552134929	1	< 0.1%
0.549162396	1	< 0.1%
0.222073909	1	< 0.1%
0.878886786	1	< 0.1%
Other values (8940)	8940	99.9%

Value	Count	Frequency (%)
0	1	< 0.1%
0.01843335	1	< 0.1%
0.028159527	1	< 0.1%
0.032930782	1	< 0.1%
0.036814876	1	< 0.1%
0.044216755	1	< 0.1%
0.045430799	1	< 0.1%
0.051737891	1	< 0.1%
0.053180794	1	< 0.1%
0.054541241	1	< 0.1%

Value	Count	Frequency (%)
1	1	< 0.1%
0.999228986	1	< 0.1%
0.994951549	1	< 0.1%
0.988006445	1	< 0.1%
0.985836738	1	< 0.1%
0.982656168	1	< 0.1%
0.981889332	1	< 0.1%
0.979582744	1	< 0.1%
0.979260456	1	< 0.1%
0.97764373	1	< 0.1%

F_AVANCE_EFECTIVO
Real number (ℝ)

High correlation Unique

Distinct	8950
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.73494611

Minimum	0
Maximum	1.5
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	397.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0.13012927
Q1	0.23071552
median	0.94765112
Q3	1.0291717
95-th percentile	1.3199466
Maximum	1.5
Range	1.5
Interquartile range (IQR)	0.79845615

Descriptive statistics

Standard deviation	0.42256259
Coefficient of variation (CV)	0.57495724
Kurtosis	-1.486247
Mean	0.73494611
Median Absolute Deviation (MAD)	0.15087962
Skewness	-0.35139224
Sum	6577.7677
Variance	0.17855914
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.194501644	1	< 0.1%
0.951120651	1	< 0.1%
0.961277649	1	< 0.1%
0.178319851	1	< 0.1%
1.004010144	1	< 0.1%
1.146789182	1	< 0.1%
1.04901538	1	< 0.1%
1.060168412	1	< 0.1%
1.357379426	1	< 0.1%
0.193118907	1	< 0.1%
Other values (8940)	8940	99.9%

Value	Count	Frequency (%)
0	1	< 0.1%
0.005993094	1	< 0.1%
0.011819193	1	< 0.1%
0.013748532	1	< 0.1%
0.015169869	1	< 0.1%
0.016549447	1	< 0.1%
0.019757976	1	< 0.1%
0.020842636	1	< 0.1%
0.021314779	1	< 0.1%
0.022455455	1	< 0.1%

Value	Count	Frequency (%)
1.5	1	< 0.1%
1.49104669	1	< 0.1%
1.478030738	1	< 0.1%
1.469423469	1	< 0.1%
1.468218163	1	< 0.1%
1.463748383	1	< 0.1%
1.456969054	1	< 0.1%
1.456421979	1	< 0.1%
1.45468774	1	< 0.1%
1.454311881	1	< 0.1%

P_AVANCE_EFECTIVO
Real number (ℝ)

High correlation

Distinct	118
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	76.169162

Minimum	0
Maximum	123
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	397.9 KiB

Quantile statistics

Minimum	0
5-th percentile	29
Q1	65
median	82
Q3	92
95-th percentile	103
Maximum	123
Range	123
Interquartile range (IQR)	27

Descriptive statistics

Standard deviation	22.260935
Coefficient of variation (CV)	0.29225653
Kurtosis	0.17016868
Mean	76.169162
Median Absolute Deviation (MAD)	11
Skewness	-0.95661627
Sum	681714
Variance	495.54921
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
85	260	2.9%
84	250	2.8%
87	243	2.7%
90	234	2.6%
88	234	2.6%
83	231	2.6%
86	230	2.6%
81	230	2.6%
82	228	2.5%
89	223	2.5%
Other values (108)	6587	73.6%

Value	Count	Frequency (%)
0	1	< 0.1%
3	2	< 0.1%
5	3	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	4	< 0.1%
10	2	< 0.1%
12	8	0.1%
13	8	0.1%
14	10	0.1%

Value	Count	Frequency (%)
123	1	< 0.1%
121	1	< 0.1%
120	4	< 0.1%
119	2	< 0.1%
118	1	< 0.1%
117	2	< 0.1%
116	8	0.1%
115	4	< 0.1%
114	5	0.1%
113	10	0.1%

P_COMPRAS
Real number (ℝ)

High correlation

Distinct	331
Distinct (%)	3.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	164.98145

Minimum	0
Maximum	358
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	397.9 KiB

Quantile statistics

Minimum	0
5-th percentile	59
Q1	97
median	176
Q3	216
95-th percentile	287
Maximum	358
Range	358
Interquartile range (IQR)	119

Descriptive statistics

Standard deviation	71.322003
Coefficient of variation (CV)	0.43230316
Kurtosis	-0.9073774
Mean	164.98145
Median Absolute Deviation (MAD)	57
Skewness	0.078237319
Sum	1476584
Variance	5086.8281
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
209	72	0.8%
192	67	0.7%
196	66	0.7%
206	66	0.7%
214	65	0.7%
205	65	0.7%
201	64	0.7%
213	64	0.7%
194	62	0.7%
202	62	0.7%
Other values (321)	8297	92.7%

Value	Count	Frequency (%)
0	1	< 0.1%
8	1	< 0.1%
10	2	< 0.1%
15	2	< 0.1%
16	1	< 0.1%
17	4	< 0.1%
20	1	< 0.1%
21	1	< 0.1%
22	1	< 0.1%
23	1	< 0.1%

Value	Count	Frequency (%)
358	1	< 0.1%
351	1	< 0.1%
350	1	< 0.1%
349	2	< 0.1%
348	1	< 0.1%
347	1	< 0.1%
345	1	< 0.1%
342	3	< 0.1%
340	1	< 0.1%
338	4	< 0.1%

LÍMITE_CREDITO
Real number (ℝ)

High correlation

Distinct	8949
Distinct (%)	100.0%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	14696.64

Minimum	50
Maximum	30000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	397.9 KiB

Quantile statistics

Minimum	50
5-th percentile	3904.0634
Q1	13487.727
median	14942.545
Q3	16269.727
95-th percentile	26139.173
Maximum	30000
Range	29950
Interquartile range (IQR)	2781.9998

Descriptive statistics

Standard deviation	5537.0747
Coefficient of variation (CV)	0.37675785
Kurtosis	0.94614967
Mean	14696.64
Median Absolute Deviation (MAD)	1381.6762
Skewness	0.018925049
Sum	1.3152023 × 10⁸
Variance	30659196
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16819.48004	1	< 0.1%
13489.83458	1	< 0.1%
14023.51913	1	< 0.1%
15672.74711	1	< 0.1%
15771.35508	1	< 0.1%
15205.50881	1	< 0.1%
16927.76517	1	< 0.1%
14721.74873	1	< 0.1%
27347.93593	1	< 0.1%
16362.29711	1	< 0.1%
Other values (8939)	8939	99.9%

Value	Count	Frequency (%)
50	1	< 0.1%
133.919532	1	< 0.1%
504.2268287	1	< 0.1%
580.0112044	1	< 0.1%
646.9910694	1	< 0.1%
680.3749224	1	< 0.1%
732.8415517	1	< 0.1%
776.9563119	1	< 0.1%
796.6130275	1	< 0.1%
867.128434	1	< 0.1%

Value	Count	Frequency (%)
30000	1	< 0.1%
29905.60826	1	< 0.1%
29818.70965	1	< 0.1%
29669.97528	1	< 0.1%
29645.60622	1	< 0.1%
29544.21431	1	< 0.1%
29502.22828	1	< 0.1%
29339.72126	1	< 0.1%
29315.78973	1	< 0.1%
29293.07003	1	< 0.1%

PAGOS
Real number (ℝ)

High correlation Unique

Distinct	8950
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19824.347

Minimum	0
Maximum	50721.483
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	397.9 KiB

Quantile statistics

Minimum	0
5-th percentile	6088.4929
Q1	9329.6031
median	21367.621
Q3	25219.127
95-th percentile	43827.557
Maximum	50721.483
Range	50721.483
Interquartile range (IQR)	15889.524

Descriptive statistics

Standard deviation	11069.268
Coefficient of variation (CV)	0.55836735
Kurtosis	-0.067413052
Mean	19824.347
Median Absolute Deviation (MAD)	7608.515
Skewness	0.67538125
Sum	1.7742791 × 10⁸
Variance	1.225287 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
21337.02746	1	< 0.1%
9120.361516	1	< 0.1%
8036.844158	1	< 0.1%
24779.04808	1	< 0.1%
7076.890278	1	< 0.1%
6738.704191	1	< 0.1%
8419.502739	1	< 0.1%
9107.000329	1	< 0.1%
37994.25	1	< 0.1%
24692.94081	1	< 0.1%
Other values (8940)	8940	99.9%

Value	Count	Frequency (%)
0	1	< 0.1%
1503.315614	1	< 0.1%
1604.581013	1	< 0.1%
1899.629874	1	< 0.1%
1909.85867	1	< 0.1%
1924.758371	1	< 0.1%
2232.888478	1	< 0.1%
2289.554519	1	< 0.1%
2694.995305	1	< 0.1%
2706.069721	1	< 0.1%

Value	Count	Frequency (%)
50721.48336	1	< 0.1%
50472.32637	1	< 0.1%
50380.26434	1	< 0.1%
49623.81552	1	< 0.1%
49223.49462	1	< 0.1%
48952.659	1	< 0.1%
48937.42629	1	< 0.1%
48811.44262	1	< 0.1%
48727.94939	1	< 0.1%
48562.3712	1	< 0.1%

PAGOS_MINIMOS
Real number (ℝ)

High correlation Missing

Distinct	8637
Distinct (%)	100.0%
Missing	313
Missing (%)	3.5%
Infinite	0
Infinite (%)	0.0%
Mean	44222.978

Minimum	1006.065
Maximum	76406.208
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	397.9 KiB

Quantile statistics

Minimum	1006.065
5-th percentile	17045.676
Q1	31572.128
median	48780.272
Q3	57761.176
95-th percentile	64111.498
Maximum	76406.208
Range	75400.143
Interquartile range (IQR)	26189.048

Descriptive statistics

Standard deviation	15468.314
Coefficient of variation (CV)	0.34978002
Kurtosis	-1.0697059
Mean	44222.978
Median Absolute Deviation (MAD)	12457.93
Skewness	-0.35549673
Sum	3.8195386 × 10⁸
Variance	2.3926875 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
39452.95812	1	< 0.1%
56255.79157	1	< 0.1%
40940.8495	1	< 0.1%
59390.27296	1	< 0.1%
61481.52889	1	< 0.1%
50366.75465	1	< 0.1%
33988.64039	1	< 0.1%
27619.23845	1	< 0.1%
59918.19036	1	< 0.1%
35039.86352	1	< 0.1%
Other values (8627)	8627	96.4%
(Missing)	313	3.5%

Value	Count	Frequency (%)
1006.064965	1	< 0.1%
2160.629738	1	< 0.1%
3038.547949	1	< 0.1%
3210.910539	1	< 0.1%
4080.545925	1	< 0.1%
4400.615012	1	< 0.1%
4408.570208	1	< 0.1%
5081.015028	1	< 0.1%
5590.445073	1	< 0.1%
5776.494624	1	< 0.1%

Value	Count	Frequency (%)
76406.20752	1	< 0.1%
75375.06471	1	< 0.1%
73989.66709	1	< 0.1%
73852.0694	1	< 0.1%
73606.51716	1	< 0.1%
73136.23537	1	< 0.1%
72714.63958	1	< 0.1%
72650.9874	1	< 0.1%
72141.59346	1	< 0.1%
72065.2961	1	< 0.1%

F_PAGOS_COMPLETOS
Real number (ℝ)

High correlation Unique

Distinct	8950
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.54541448

Minimum	0
Maximum	1
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	397.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0.13330137
Q1	0.33673232
median	0.43268965
Q3	0.81517791
95-th percentile	0.89000698
Maximum	1
Range	1
Interquartile range (IQR)	0.47844559

Descriptive statistics

Standard deviation	0.26744263
Coefficient of variation (CV)	0.4903475
Kurtosis	-1.5198974
Mean	0.54541448
Median Absolute Deviation (MAD)	0.28094339
Skewness	-0.064546367
Sum	4881.4596
Variance	0.071525558
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.817906647	1	< 0.1%
0.414472591	1	< 0.1%
0.386041948	1	< 0.1%
0.823809481	1	< 0.1%
0.406787958	1	< 0.1%
0.356113009	1	< 0.1%
0.41343092	1	< 0.1%
0.326115516	1	< 0.1%
0.74219514	1	< 0.1%
0.909980664	1	< 0.1%
Other values (8940)	8940	99.9%

Value	Count	Frequency (%)
0	1	< 0.1%
0.012136856	1	< 0.1%
0.020148508	1	< 0.1%
0.021707718	1	< 0.1%
0.023528331	1	< 0.1%
0.029629837	1	< 0.1%
0.032417556	1	< 0.1%
0.032610948	1	< 0.1%
0.032906928	1	< 0.1%
0.033161956	1	< 0.1%

Value	Count	Frequency (%)
1	1	< 0.1%
0.993136775	1	< 0.1%
0.991642838	1	< 0.1%
0.991604933	1	< 0.1%
0.986776402	1	< 0.1%
0.983996727	1	< 0.1%
0.981609131	1	< 0.1%
0.980439591	1	< 0.1%
0.979336983	1	< 0.1%
0.978045132	1	< 0.1%

MESES_CLIENTE
Real number (ℝ)

High correlation

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.3706145

Minimum	6
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	397.9 KiB

Quantile statistics

Minimum	6
5-th percentile	6
Q1	7
median	8
Q3	10
95-th percentile	11
Maximum	12
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.7560353
Coefficient of variation (CV)	0.2097857
Kurtosis	-1.5628377
Mean	8.3706145
Median Absolute Deviation (MAD)	2
Skewness	-0.13397164
Sum	74917
Variance	3.0836598
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
10	3336	37.3%
6	2091	23.4%
7	1414	15.8%
8	1021	11.4%
11	575	6.4%
9	512	5.7%
12	1	< 0.1%

Value	Count	Frequency (%)
6	2091	23.4%
7	1414	15.8%
8	1021	11.4%
9	512	5.7%
10	3336	37.3%
11	575	6.4%
12	1	< 0.1%

Value	Count	Frequency (%)
12	1	< 0.1%
11	575	6.4%
10	3336	37.3%
9	512	5.7%
8	1021	11.4%
7	1414	15.8%
6	2091	23.4%

	AVANCE_EFECTIVO	COMPRAS	COMPRAS_PLAZOS	COMPRAS_PUNTUALES	F_AVANCE_EFECTIVO	F_COMPRAS	F_COMPRAS_PLAZOS	F_COMPRAS_PUNTUALES	F_PAGOS_COMPLETOS	F_SALDO	LÍMITE_CREDITO	MESES_CLIENTE	PAGOS	PAGOS_MINIMOS	P_AVANCE_EFECTIVO	P_COMPRAS	SALDO
AVANCE_EFECTIVO	1.000	0.606	0.791	-0.769	0.355	0.822	-0.428	-0.679	-0.642	0.652	-0.392	0.507	-0.833	0.790	0.504	0.424	0.673
COMPRAS	0.606	1.000	0.563	-0.587	0.071	0.660	-0.278	-0.833	-0.080	0.703	0.052	0.379	-0.651	0.467	0.723	0.259	0.147
COMPRAS_PLAZOS	0.791	0.563	1.000	-0.859	0.611	0.719	-0.699	-0.565	-0.677	0.764	-0.230	0.762	-0.727	0.680	0.365	0.686	0.568
COMPRAS_PUNTUALES	-0.769	-0.587	-0.859	1.000	-0.595	-0.704	0.688	0.575	0.628	-0.768	0.188	-0.754	0.712	-0.653	-0.379	-0.674	-0.518
F_AVANCE_EFECTIVO	0.355	0.071	0.611	-0.595	1.000	0.200	-0.799	0.004	-0.577	0.492	-0.006	0.795	-0.212	0.246	-0.164	0.798	0.281
F_COMPRAS	0.822	0.660	0.719	-0.704	0.200	1.000	-0.290	-0.749	-0.544	0.609	-0.400	0.376	-0.850	0.789	0.603	0.283	0.642
F_COMPRAS_PLAZOS	-0.428	-0.278	-0.699	0.688	-0.799	-0.290	1.000	0.170	0.500	-0.654	-0.101	-0.881	0.296	-0.269	0.007	-0.854	-0.209
F_COMPRAS_PUNTUALES	-0.679	-0.833	-0.565	0.575	0.004	-0.749	0.170	1.000	0.173	-0.637	0.127	-0.272	0.745	-0.590	-0.748	-0.150	-0.306
F_PAGOS_COMPLETOS	-0.642	-0.080	-0.677	0.628	-0.577	-0.544	0.500	0.173	1.000	-0.360	0.533	-0.516	0.567	-0.673	-0.016	-0.510	-0.795
F_SALDO	0.652	0.703	0.764	-0.768	0.492	0.609	-0.654	-0.637	-0.360	1.000	0.051	0.728	-0.605	0.478	0.460	0.637	0.247
LÍMITE_CREDITO	-0.392	0.052	-0.230	0.188	-0.006	-0.400	-0.101	0.127	0.533	0.051	1.000	0.087	0.416	-0.528	-0.075	0.091	-0.669
MESES_CLIENTE	0.507	0.379	0.762	-0.754	0.795	0.376	-0.881	-0.272	-0.516	0.728	0.087	1.000	-0.383	0.336	0.082	0.868	0.245
PAGOS	-0.833	-0.651	-0.727	0.712	-0.212	-0.850	0.296	0.745	0.567	-0.605	0.416	-0.383	1.000	-0.805	-0.596	-0.288	-0.663
PAGOS_MINIMOS	0.790	0.467	0.680	-0.653	0.246	0.789	-0.269	-0.590	-0.673	0.478	-0.528	0.336	-0.805	1.000	0.446	0.269	0.761
P_AVANCE_EFECTIVO	0.504	0.723	0.365	-0.379	-0.164	0.603	0.007	-0.748	-0.016	0.460	-0.075	0.082	-0.596	0.446	1.000	-0.020	0.182
P_COMPRAS	0.424	0.259	0.686	-0.674	0.798	0.283	-0.854	-0.150	-0.510	0.637	0.091	0.868	-0.288	0.269	-0.020	1.000	0.218
SALDO	0.673	0.147	0.568	-0.518	0.281	0.642	-0.209	-0.306	-0.795	0.247	-0.669	0.245	-0.663	0.761	0.182	0.218	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	SALDO	F_SALDO	COMPRAS	COMPRAS_PUNTUALES	COMPRAS_PLAZOS	AVANCE_EFECTIVO	F_COMPRAS	F_COMPRAS_PUNTUALES	F_COMPRAS_PLAZOS	F_AVANCE_EFECTIVO	P_AVANCE_EFECTIVO	P_COMPRAS	LÍMITE_CREDITO	PAGOS	PAGOS_MINIMOS	F_PAGOS_COMPLETOS	MESES_CLIENTE
ID
C10001	5323.148883	0.250693	26344.07220	38237.442520	3727.113162	15708.239680	0.496536	0.464442	0.821611	0.194502	100	77	16819.48004	21337.027460	39452.95812	0.817907	7
C10002	12726.638120	0.791307	37958.51902	5690.742440	18733.810960	38284.354430	0.699457	0.250327	0.654863	1.083902	78	156	15617.57058	8000.183624	63013.74848	0.343119	9
C10003	4305.572068	0.176531	28392.95334	36009.470090	2873.383232	14294.185030	0.419764	0.523662	0.899912	0.207049	72	81	15515.58621	27111.360490	NaN	0.829074	6
C10004	4740.988511	0.178076	27399.00384	38246.863490	3402.853375	6936.812518	0.439666	0.606597	0.783129	0.228299	78	83	12926.58797	23919.113400	38444.21998	0.883984	7
C10005	13820.920640	0.826914	42214.02163	7341.007821	19273.070990	40091.347850	0.821412	0.283579	0.501361	1.106350	88	182	14404.70507	6994.688474	62041.61734	0.383186	10
C10006	12439.064890	0.706673	40674.22612	6156.208831	19401.475610	32438.912700	0.836764	0.343936	0.527813	0.970693	103	216	14554.91155	8814.239865	58227.56469	0.398377	10
C10007	5751.875116	0.202635	32509.15916	34929.992110	2951.501163	15831.777600	0.433735	0.572119	0.848748	0.257982	80	99	16427.99721	26477.357790	19768.61317	0.919282	6
C10008	11958.850430	0.731274	40494.41581	9571.367143	18972.549000	34492.971030	0.871211	0.068437	0.509161	0.968966	72	197	14040.66521	5679.381669	52698.25158	0.372649	10
C10009	12887.080990	0.871732	37655.94850	7249.847190	20221.263170	38881.678340	0.884932	0.326394	0.562211	1.011474	88	217	14514.68978	8457.493288	57985.42120	0.307665	10
C10010	4175.239250	0.234524	27697.46442	34065.742050	4428.638371	14519.219130	0.445582	0.624615	0.920826	0.268456	78	88	14888.13154	27044.161560	30451.40382	0.881308	6

	SALDO	F_SALDO	COMPRAS	COMPRAS_PUNTUALES	COMPRAS_PLAZOS	AVANCE_EFECTIVO	F_COMPRAS	F_COMPRAS_PUNTUALES	F_COMPRAS_PLAZOS	F_AVANCE_EFECTIVO	P_AVANCE_EFECTIVO	P_COMPRAS	LÍMITE_CREDITO	PAGOS	PAGOS_MINIMOS	F_PAGOS_COMPLETOS	MESES_CLIENTE
ID
C18941	16092.289720	0.211874	8585.338246	29785.218440	10502.263110	17707.345730	0.552723	0.695264	0.693813	1.016379	49	139	5320.343989	23574.224600	47530.66378	0.170916	8
C18942	13434.274470	0.758648	42511.209220	3679.376217	18827.429530	35136.779640	0.752240	0.256360	0.525504	1.099723	87	202	13975.078000	7020.073130	58548.04446	0.417750	10
C18943	5123.877238	0.175270	32472.729900	32842.887680	3872.892582	11315.386040	0.424672	0.482375	0.871242	0.186818	78	106	16501.839490	24960.862320	NaN	0.880880	7
C18944	11658.261330	0.787877	40468.623790	5411.361875	18894.477550	40461.053900	0.970439	0.183322	0.500901	1.105921	96	145	14508.142380	4600.568825	56319.07507	0.342270	9
C18945	15119.928760	0.246108	10546.669410	32155.784720	11235.846880	21376.195980	0.547621	0.783679	0.592171	0.965899	29	120	4865.173639	19403.205050	53664.11661	0.208691	8
C18946	6095.221156	0.234346	27094.007820	35917.204380	3463.821376	11711.578890	0.469832	0.539477	0.828321	0.191030	75	101	17623.810280	23954.396950	34841.82989	0.866856	7
C18947	12682.575820	0.686025	38433.618850	5293.541956	18924.799800	34444.867320	0.710331	0.276426	0.546059	0.935152	95	170	12433.814930	7375.625322	66726.37299	0.306600	10
C18948	16464.311410	0.189136	4296.196384	32554.759640	11231.500430	15214.671560	0.424665	0.746010	0.690380	1.063788	51	151	3307.587117	22947.759220	54761.96221	0.129242	8
C18949	15531.883780	0.117118	12219.325650	31795.971700	12390.432130	13856.393210	0.450670	0.805140	0.608737	1.058548	61	178	6148.232910	21369.503520	50368.30906	0.087448	8
C18950	5852.488566	0.166820	32480.936200	32368.357730	2825.555518	8540.930924	0.448753	0.554458	0.863972	0.202943	87	91	17179.147460	24703.925210	33166.54256	0.819986	7

Overview

Interactions

Correlations

Missing values

Sample

Overview

Variables

Interactions

Correlations

Missing values

Sample